Problem Note 59763: The Load_STG2DM_Product_hier_assoc_dm job generates "ERROR 22-322: Syntax error, expecting one of the following: (, '.', AS, LIKE."
 |  |  |  |  |
The SAS® Promotion Optimization Load_STG2DM_Product_hier_assoc_dm job might generate the following error in the Load_STG2DM_Product_hier_assoc_dm.log file:
Running for Plan <PLAN_SK>
...
ERROR 22-322: Syntax error, expecting one of the following: (, '.', AS, LIKE.
ERROR 200-322: The symbol is not recognized and will be ignored.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
ERROR 22-322: Syntax error, expecting one of the following: ;, (, APPENDVER, APPENDVERSION, BASE, CREATE, DATA, FORCE, GETSORT,
NEW, NOWARN, OUT.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR: File WORK.TMP_.DATA does not exist.
ERROR 22-322: Syntax error, expecting one of the following: (, '.', AS, LIKE.
ERROR 200-322: The symbol is not recognized and will be ignored.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
ERROR 22-322: Syntax error, expecting one of the following: ;, (, APPENDVER, APPENDVERSION, BASE, CREATE, DATA, FORCE, GETSORT,
NEW, NOWARN, OUT.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR: File WORK.TMP_.DATA does not exist.
NOTE: Statements not processed because of errors noted above.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE APPEND used (Total process time):
real time 0.00 seconds
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE APPEND used (Total process time):
real time 0.00 seconds
This error occurs when PLAN_SK is a negative value. This error occurs when a plan with a negative PLAN_SK value is impacted by a reclassification introduced during the data load. Negative PLAN_SK values are generated by the restore vendor deal support functionality and not visible in the UI.
No corrective action is necessary for this error. Simply follow your process to resume your ETL and weekly batch jobs.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M4 | ||
A fix for this issue for SAS Revenue Optimization 5.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P20.html#59763| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-01-23 11:03:04 |
| Date Created: | 2017-01-23 09:05:55 |